Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CONSIDER

The CONSIDER command identifies a definition as the current definition. This enables you to add a description, value name format, formula, program, model, permission, or property to the definition with an LD, VNF, EQ, PROGRAM, MODEL, PERMIT, or PROPERTY statement.

Syntax

CONSIDER name

Arguments

name

  The name of a definition in the current workspace or in an attached workspace.

Notes

Replacing a Definition Component

When you use an LD, VNF, EQ, PROGRAM, MODEL, or PERMIT statement to add a component to the current definition, any existing value for that component is discarded and replaced by the new value you specify. For the PROPERTY statement, the value is replaced only when you specify a new value for an existing property name. Definitions can have more than one property.

Unsuccessful CONSIDER Statements

When the CONSIDER command you issue is unsuccessful, subsequent LD, VNF, EQ, PROGRAM, MODEL, PERMIT, or PROPERTY statements produce an error.

Implicit CONSIDER Statements

The DEFINE, COPYDFN, and RENAME statement automatically issue an implicit CONSIDER command.

Examples

Example 9-17 Adding a Description to an Analytic Workspace Object

This example adds a description (LD) to the definition for `district`. To add the LD, you must first use CONSIDER to make `district` the current definition. The statements

    CONSIDER district
    LD Sales Districts
    DESCRIBE district

produce the following definition.

    DEFINE district DIMENSION TEXT
    LD Sales Districts